﻿CREATE TABLE [dbo].[LogData]
(
[ContextKey] [nvarchar] (300) NOT NULL,
[Id] [nvarchar] (40) NOT NULL DEFAULT CONVERT(nvarchar(40), newid()),
[UrlRequested] [nvarchar] (400) NULL,
[ReferrerUrl] [nvarchar] (400) NULL,
[ReferrerTitle] [nvarchar] (200) NULL,
[ReferrerName] [nvarchar] (200) NULL,
[TargetId] [nvarchar] (400) NULL,
[TargetTitle] [nvarchar] (400) NULL,
[UserAgent] [nvarchar] (400) NULL,
[UserDomain] [nvarchar] (200) NULL,
[RequestTime] [datetime] NULL,
[UserIP] [nvarchar] (50) NULL,
[TrackingType] [nvarchar] (20) NULL,
[Country] [nchar] (2) NULL,
[Location] [nvarchar] (50) NULL
) ON [PRIMARY]


